<?php 
//---------版块列表页----------
//包含数据库配置文件
include '../../public/dbconfig.php';
//包含函数库文件
include '../../public/func.inc.php';
//调用函数
$link = conn();

?>

<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>主要内容区main</title>
<link href="../css/css.css" type="text/css" rel="stylesheet" />
<link href="../css/main.css" type="text/css" rel="stylesheet" />
<link rel="shortcut icon" href="images/main/favicon.ico" />
<style>
body{overflow-x:hidden; background:#f2f0f5; padding:15px 0px 10px 5px;}
#searchmain{ font-size:12px;}
#search{ font-size:12px; background:#548fc9; margin:10px 10px 0 0; display:inline; width:100%; color:#FFF; float:left}
#search form span{height:40px; line-height:40px; padding:0 0px 0 10px; float:left;}
#search form input.text-word{height:24px; line-height:24px; width:180px; margin:8px 0 6px 0; padding:0 0px 0 10px; float:left; border:1px solid #FFF;}
#search form input.text-but{height:24px; line-height:24px; width:55px; background:url(images/main/list_input.jpg) no-repeat left top; border:none; cursor:pointer; font-family:"Microsoft YaHei","Tahoma","Arial",'宋体'; color:#666; float:left; margin:8px 0 0 6px; display:inline;}
#search a.add{ background:url(images/main/add.jpg) no-repeat -3px 7px #548fc9; padding:0 10px 0 26px; height:40px; line-height:40px; font-size:14px; font-weight:bold; color:#FFF; float:right}
#search a:hover.add{ text-decoration:underline; color:#d2e9ff;}
#main-tab{ border:1px solid #eaeaea; background:#FFF; font-size:12px;}
#main-tab th{ font-size:12px; background:url(images/main/list_bg.jpg) repeat-x; height:32px; line-height:32px;}
#main-tab td{ font-size:12px; line-height:40px;}
#main-tab td a{ font-size:12px; color:#548fc9;}
#main-tab td a:hover{color:#565656; text-decoration:underline;}
.bordertop{ border-top:1px solid #ebebeb}
.borderright{ border-right:1px solid #ebebeb}
.borderbottom{ border-bottom:1px solid #ebebeb}
.borderleft{ border-left:1px solid #ebebeb}
.gray{ color:#dbdbdb;}
td.fenye{ padding:10px 0 0 0; text-align:right;}
.bggray{ background:#f9f9f9}
</style>
</head>
<body>
<!--main_top-->
<table width="99%" border="0" cellspacing="0" cellpadding="0" id="searchmain">
  <tr>
    <td width="99%" align="left" valign="top">您的位置：版块管理</td>
  </tr>
  <tr>
    <td align="left" valign="top">
    <table width="100%" border="0" cellspacing="0" cellpadding="0" id="search">
  		<tr>
   		 <td width="90%" align="left" valign="middle">
		 <!--搜索要以get方式提交 提交到本页面进行搜索-->
	         <form method="get" action="list.php">
	         <span>版块名：</span>
	         <input type="text" name="cname" value="" class="text-word">
	         <input name="" type="submit" value="搜索" class="text-but">
	         </form>
         </td>
  		  <td width="10%" align="center" valign="middle" style="text-align:right; width:150px;"><a href="add.php" target="mainFrame" onFocus="this.blur()" class="add">新增版块名称</a></td>
  		</tr>
	</table>
    </td>
  </tr>
  <tr>
    <td align="left" valign="top">
    
    <table width="100%" border="0" cellspacing="0" cellpadding="0" id="main-tab">
      <tr>
        <th align="center" valign="middle" class="borderright">编号</th>
		<th align="center" valign="middle" class="borderright">分区名称</th>
        <th align="center" valign="middle" class="borderright">版块名称</th>
		<th align="center" valign="middle" class="borderright">添加时间</th>
        <th align="center" valign="middle">操作</th>
      </tr>
	  <?php
		
		//------------分页---------
		//当前页  如果点击链接传页数 就使用传的页数 否则就是第1页
		$page = isset($_GET['page']) ? $_GET['page'] : 1;
		
		//每页显示的条数
		$pageRow = 2;
		//n 当前页-1 * 每页显示条数
		$offset = ($page - 1) * $pageRow;
		//分页原理  n,m
		$limit = "limit {$offset},{$pageRow}";
		//var_dump($limit);
		//exit;
		//------查询语句---------
		$sql = "select c.id,p.pname,c.cname,c.ctime from bbs_part p,bbs_cate c where p.id=c.pid  {$limit}";
		
		//var_dump($sql);
		//exit;
		//---------执行语句----------
		$res = mysqli_query($link,$sql);
		//var_dump($res);
		//exit;
		//---------循环获取关联表中数据------------
		if($res){
			$i = 0;
			while($cinfo = mysqli_fetch_assoc($res)){
				//var_dump($pinfo);
				//exit;
				$i++;
		?>
		<!--把关联表中的数据显示在表单中-->
      <tr onMouseOut="this.style.backgroundColor='#ffffff'" onMouseOver="this.style.backgroundColor='#edf5ff'">
        <td align="center" valign="middle" class="borderright borderbottom"><?php echo $i;?></td>
		<td align="center" valign="middle" class="borderright borderbottom"><?php echo $cinfo['pname'];?></td>
        <td align="center" valign="middle" class="borderright borderbottom"><?php echo $cinfo['cname'];?></td>
		<td align="center" valign="middle" class="borderright borderbottom"><?php echo date('Y-m-d',$cinfo['ctime']);?></td>
        <td align="center" valign="middle" class="borderbottom">
		<!--版块进行编辑修改 a连接以get方式进行提交 提交到 edit.php页面-->
		<a href="edit.php?cid=<?php echo $cinfo['id'];?>&cname=<?php echo $cinfo['cname'];?>" target="mainFrame" onFocus="this.blur()" class="add">编辑</a><span class="gray">&nbsp;|&nbsp;</span>
		<!--版块进行删除 a连接以get方式进行提交 提交到 delete.php页面-->
		<a href="delete.php?cid=<?php echo $cinfo['id'];?>" target="mainFrame" onFocus="this.blur()" class="add">删除</a></td>
      </tr>
	  <?php
			}
		}
	  ?>
      
    </table>
	
	
	</td>
    </tr>
	<?php
	//---------总条数---------
	//总条数
	$csql = "select count(*) as c from bbs_cate";
	$cres = mysqli_query($link,$csql);
	$cinfo = mysqli_fetch_assoc($cres);
	//var_dump($cinfo);
	//-------------总页数------------
	//求总页数  = ceil(总条数 / 每页显示的条数)  进一法取整
	$countPage = ceil($cinfo['c'] / $pageRow);
	//--------------下一页----------------------
	//计算下一页  当前页 + 1
 	$nextPage = $page + 1;
	//越界判断  如果超过总页数 值就为总页数
	if($nextPage > $countPage){
		$nextPage = $countPage;
	}
	//-------------上一页--------
	//计算上一页 当前页 - 1
	$prevPage = $page - 1;
	//越界判断 如果小于1 就为1
	if($prevPage < 1){
		$prevPage = 1;
	}
	
	?>
  <tr>
    <td align="left" valign="top" class="fenye">共<?php echo $cinfo['c'];?>条数据 <?php echo $page;?>/<?php echo $countPage?> 页&nbsp;&nbsp;<a href="list.php?page=1" target="mainFrame" onFocus="this.blur()">首页</a>&nbsp;&nbsp;<a href="list.php?page=<?php echo $prevPage.$url;?>" target="mainFrame" onFocus="this.blur()">上一页</a>&nbsp;&nbsp;<a href="list.php?page=<?php echo $nextPage.$url;?>" target="mainFrame" onFocus="this.blur()">下一页</a>&nbsp;&nbsp;<a href="list.php?page=<?php echo $countPage.$url;?>" target="mainFrame" onFocus="this.blur()">尾页</a></td>
  </tr>
</table>
</body>
</html>